// See the DataAccess setup code on the DataAccess class page.

// Executes a Select statement and retrieves the DbDataReader object.
private static void GetDataReader(DataAccess dataAccess)
{
    DbDataReader dbDataReader = null;

    string sql = "select * from TableName";
    try
    {
        // The "using" statement disposes the object when the scope is exited.
        using (dbDataReader = dataAccess.GetDataReader(sql))
        {
            while (dbDataReader.Read())
            {
                // Use the record here.
                for int index = 0; index < dbDataReader.FieldCount; index++)
                {
                    string value = dbDataReader[index].ToString();
                }
            }
        }
    }
    finally
    {
        // The calling program must close the connection when done.
        dataAccess.CloseConnection();
    }
}